package com.apes.fn.controlWaitDisposal;

import com.apes.framework.jpa.repository.CustomRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;
import java.util.Map;

/**
 * @program: apes-server
 * @description
 * @author: czs
 * @create: 2021-05-21 14:07
 **/
public interface WaitSubmissionRepository extends CustomRepository<WaitSubmission, String> {
    @Query(value = "SELECT COUNT(*) WAIT_SUBMISSION  FROM FN_SERVICE_WAIT_SUBMISSION I WHERE I.BELONG_DEPT_ID = ?1 " +
            "AND I.STATE IN('create','techAudit','backTechAudit','priceAudit','backPriceAudit','inquiryFinish','backInquiry')", nativeQuery = true)
    List<Map> queryWaitSubmission(String dept);


}
